home *** CD-ROM | disk | FTP | other *** search
/ Celestin Apprentice 5 / Apprentice-Release5.iso / Demos / A.D. Software / OOFILE / Buildable, limited OOFILE / samples / ooftst20.cpp < prev    next >
C/C++ Source or Header  |  1996-03-21  |  3KB  |  126 lines
  1. // Copyright 1994 A.D. Software. All Rights Reserved
  2.  
  3. // OOFTEST20
  4.  
  5. // This sample demonstrates how to create an ad-hoc query.
  6.  
  7. // Simple stream I/O is used to interact with the user.
  8.  
  9. #include "oofile.hpp"
  10. #include "ooftst01.inc"
  11.  
  12. void anyName(const char* searchStrings[], bool isOr, unsigned short numSch);
  13. void lastName(const char* searchStrings[], unsigned short numSch);
  14.  
  15. #define numEntries(A) sizeof(A)/sizeof(A[0])
  16.  
  17.     dbConnect_ctree    theDB;
  18.     dbPeople     People;
  19.  
  20.  
  21. int main()
  22. {
  23.     cout << "OOFILE Validation Suite - Test 20\n"
  24.          << "Demonstration of ad-hoc query building\n";
  25.     
  26.     theDB.useSeparateFiles();  // note the blank connection names!
  27. // this test creates People.dat, People.idx & Blobs
  28.  
  29. #ifdef _Macintosh
  30. // this feature only on the Mac at present
  31.     #define kExistsName  ":test01:People.dat"
  32.     #define kDatabaseName "test01"
  33. #else
  34.     #define kExistsName "People.dat"
  35.     #define kDatabaseName ""
  36. #endif    
  37.  
  38.     if (dbConnect::fileExists(kExistsName))
  39.         theDB.openConnection(kDatabaseName);
  40.     else {
  41.         theDB.newConnection(kDatabaseName);
  42.         People.AddTestData();
  43.     }
  44.  
  45.     People.selectAll();
  46.     cout << "Listing records\n" << (dbView(People) << People.LastName << People.OtherNames);
  47.  
  48.     const char* userEntries[] = {"Dent", "Andy"};    
  49.     anyName(userEntries, true, numEntries(userEntries));
  50.     anyName(userEntries, false, numEntries(userEntries));
  51.  
  52.     const char* userEntries2[] = {"Dent", "Tay*"};    
  53.     lastName(userEntries2, numEntries(userEntries));
  54.     cout << "Test Completed" << endl;
  55.     
  56.     return EXIT_SUCCESS;
  57. } 
  58.  
  59.  
  60. void
  61. anyName(const char* searchStrings[], bool isOr, unsigned short numSch)
  62. {
  63.     dbQuery theQuery;
  64.     if (isOr)
  65.         cout << "OR";
  66.     else
  67.         cout << "AND";
  68.     cout << " Querying either Last or Othernames = \n";
  69.     
  70.     for (unsigned short i=0; i<numSch; i++) {
  71.         cout << "   " << searchStrings[i] << endl;
  72.  
  73. // construct clauses on the heap otherwise they are temporaries
  74. // which won't exist by the time we do the search()
  75.         
  76.         dbQueryClause* term1 = new dbQueryBinary(
  77.             People.LastName == searchStrings[i]
  78.         );
  79.         dbQueryClause* term2 = new dbQueryBinary(
  80.             People.OtherNames == searchStrings[i]
  81.         );
  82.  
  83. // the following is a bit subtle - the operator||
  84. // which takes pointers creates a dbQueryBinaryComboOwner
  85. // which will delete the sub-clauses
  86.         if (isOr) {
  87. //            theQuery |= (*term1 || term2); equivalent to the following
  88.             theQuery |= term1;
  89.             theQuery |= term2;
  90.         }
  91.         else
  92.             theQuery &= (*term1 || term2);
  93.     }
  94.     People.search(theQuery);
  95.  
  96.     cout << "\nListing result of query\n" 
  97.          << (dbView(People) << People.LastName << People.OtherNames) << endl;
  98.  
  99. }
  100.  
  101.  
  102.  
  103. void
  104. lastName(const char* searchStrings[], unsigned short numSch)
  105. {
  106.     dbQuery theQuery;
  107.     cout << "Querying Lastname = any of\n";
  108.     
  109.     for (unsigned short i=0; i<numSch; i++) {
  110.         cout << "   " << searchStrings[i] << endl;
  111.  
  112. // construct clauses on the heap otherwise they are temporaries
  113. // which won't exist by the time we do the search()
  114.         
  115.         dbQueryClause* theTerm = new dbQueryBinary(
  116.             People.LastName == searchStrings[i]
  117.         );
  118.  
  119.         theQuery |= theTerm;
  120.     }
  121.     People.search(theQuery);
  122.  
  123.     cout << "\nListing result of query\n" 
  124.          << (dbView(People) << People.LastName << People.OtherNames) << endl;
  125.  
  126. }